ReportingPeriodDimension

Entity Definition Logical Name : ReportingPeriodDimension Physical Name : ETL_DW3_DIM_CA_PRD_RP This table identifies and describes a named time interval used to report unit count and monetary balances and cumulative values.

Attribute	Description	Physical Name	Domain	Data Type
ReportingPeriodID (PK)	The unique system assigned identifier for a particular ReportingPeriod.	ID_PRD_RP	Identity	int
BusinessDayDate (PK)	The calendar date of the BusinessDay.	DC_DY_BSN	DateCalendar	date
Name	The business name for the reporting period.	NM_PRD_RP	Name	varchar(40)
CalendarID	A unique system assigned identifier for the Calendar.	ID_CLD	Identity	int
CalendarName	The name of the Calendar	NM_CLD	Name	varchar(40)
CalendarLevelID	A unique system assigned identifier for the CalendarLevel.	ID_CLD_LV	Identity	int
CalendarPeriodID	A unique system assigned identifier for this CalendarPeriod	ID_CLD_PRD	Identity	int
CalendarPeriodIDTreepath	Pipe delimited bottom up (left to right) list of reporting period ID's in a reporting period hierarchy.	CLD_PRD_ID_TREE_PTH	String	varchar(4000)
CalendarPeriodHierlvlpath	Pipe delimited bottom up (left to right) list of hierarchy level IDs in a reporting period	CLD_PRD_LVL_PTH	String	varchar(4000)
CalendarPeriodHierLevelNamePath	Pipe delimited bottom up (left to right) list of hierarchy level descriptions (metadata describing levels of reporting periods)	CLD_PRD_HRC_LVL_NM_PTH	String	varchar(4000)

Parent Entity	Verb Phrase	Child Entity
ReportingPeriodDimension	designates time for	RetailTransactionLineItemReportingPeriodAssociation